      1  import java.sql.Connection;

      2  import java.sql.DriverManager;

      3  import java.sql.SQLException;

      4  import java.io.FileInputStream;

      5  import java.io.IOException;

      6  import java.util.Properties;

      7

      8  /**

      9     A simple data source for getting database connections.

     10  */

     11  public class SimpleDataSource

     12  {

     13     private static String url;

     14     private static String username;

     15     private static String password;

     16

     17     /**

     18        Initializes the data source.

     19        @param fileName the name of the property file that

     20        contains the database driver, URL, username, and password

     21     */

     22     public static void init(String fileName)

     23           throws IOException, ClassNotFoundException

     24     {

     25        Properties props = new Properties();

     26        FileInputStream in = new FileInputStream(fileName);

     27        props.load(in);

     28

     29        String driver = props.getProperty("jdbc.driver");

     30        url = props.getProperty("jdbc.url");

     31        username = props.getProperty("jdbc.username");

     32        if (username == null) { username = ""; }

     33        password = props.getProperty("jdbc.password");

     34        if (password == null) { password = ""; }

     35        if (driver != null) { Class.forName(driver); }

     36     }

     37

     38     /**

     39        Gets a connection to the database.

     40        @return the database connection

     41     */

     42     public static Connection getConnection() throws SQLException

     43     {

     44        return DriverManager.getConnection(url, username, password);

     45     }

     46  }